Statistics and probability

'

(a) Make an Excel worksheet to calculate $S{S}_{xx},S{S}_{yy}$, and $S{S}_{xy}$ (Leave no cells blank - be certain to enter " 0 " wherever required. Negative values should be indicated by a minus sign. Round your answers to 2 decimal places.) Click here for the Excel Data File (b) Use the formulas to calculate the slope and intercept. (Round your answers to 3 decimal places.) (c) Use your estimated slope and intercept to make a worksheet to calculate SSE, SSR, and SST. (Leave no cells blank - be certain to enter " $O$ " wherever required. Negative values should be indicated by a minus sign. Do not round intermediate calculations, but final answers should be rounded to 3 decimal places.) (d) Calculate the $R^2$. (Round your answer to 4 decimal places.)